<?php
/**
 ***** 扶摇而上、抱守本真 ******
 * @author Dana
 * @Date 2021/6/28
 */


$db = new PDO('mysql:host=localhost;dbname=test','test','123456');

$email = $_GET['email'];
$verify_string = $_GET['verify_string'];


$sql = "UPDATE users SET verified = 1 where email={$email} and verify_string={$verify_string} and verified = 0";

var_dump($res,$sth->rowCount());

if(!$res){
    print "please try again later due to a datebase error.";
}else{
    if($sth->rowCount() == 1){
        print "Thank you ,your account is verified";
    }else{
        print "sorry,you could not be verified";
    }
}